BEGIN;

ALTER TABLE school DROP COLUMN zip;
ALTER TABLE school ADD COLUMN zip VARCHAR(6) NOT NULL;

ALTER TABLE room DROP COLUMN zip;
ALTER TABLE room ADD COLUMN zip VARCHAR(6) NOT NULL;

COMMIT;